Limitations

When defining a task with Amazon MSK as the target endpoint, the following limitations apply:

• The Amazon MSK target endpoint does not support unlimited LOB size. Therefore, when replicating from source tables with LOB columns, do not select the Allow unlimited LOB size option.

  For more information on defining LOB settings, see Target metadata.

• Batch optimized apply mode is not supported. If this mode is set, the task will automatically switch to Transactional apply mode and issue an appropriate warning.

  For more information on these modes, see Change Processing Tuning.

• Store Changes mode is not supported.

  For more information on Store Changes mode, see Adding tasks.

• Amazon MSK topic names cannot exceed 255 characters (249 from Kafka 0.10) and can only contain the following characters:

  a-z|A-Z|0-9|. (dot)|_(underscore)|-(minus)

  If the source table names exceed the maximum permitted length or contain unsupported characters, you need to either modify the names before starting the task or define a global transformation. For information on defining global transformations, see Starting the Global Transformation Rules wizard.

• The Ignore ALTER Apply Changes setting is not supported for changes to source data types and table renaming.

• Column names must begin with [A-Za-z_] (letters or an underscore) followed by [A-Za-z0-9_] (letters, digits, or an underscore). For example, _Test_ is a valid column name whereas &Test is not.

  If a source column name does not adhere to this rule, then a transformation should be used to rename the column.

• The Drop and Create table Target Table Preparation option is not supported
• The Truncate before loading Target Table Preparation option is not supported
• The DDL History and Change Data Partitioning Control tables are not supported
• DDL Changes: Dropping or renaming a table is not supported